-
Re: Formula to auto-populate a large sub-set of contact information data?
It looks like your References are created, but they aren't pointing to your other sheet. If you go back to the video, I show how to create the reference by pointing to the other sheet. Once that's fi…1 · -
Re: Formula to auto-populate a large sub-set of contact information data?
Hi there, are you looking to have your individual sheets populate the Master sheet? Or are you looking for your individual sheets to pull data from the Master?1 · -
Re: Formula to auto-populate a large sub-set of contact information data?
I gotcha. Ok, in either scenario, build your Master list. In your project sheet, You can key off the user's name to pull in the rest of their data. See explanation here: https://www.youtube.com/watch…1 · -
Re: Formula to auto-populate a large sub-set of contact information data?
You bet! Enjoy1 · -
Re: JOIN 2 numbers and maintain formatting
Hey Cpatt, I'd use something like... =ROUND([Column1]@row, 0) + " - " + ROUND([Column2]@row, 0)1 ·